package elsa.shipmapper;

import elsa.bean.ScsArchives;
import elsa.bean.service.*;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface ServiceMapper {

    //查询船舶基本信息（船检登记号）
    @Select("select CBDJH, ZWCM, YWCM, CYZWCM, IMO, HH, HDHQDM, CJGDM, CCDJH, CBLXDM, CTCLDM, ZCDD, GJDD, TJQSL, TJQZLDM, ZJZLDM, JDW, CBXS, CBXK, CKZZD, ZCCMC, JZRQ, CBZC, ZDW, ZJSM, ZJZGL, SFZX, " +
            "CBZJ, CBSBH, PBH, CBICKH, MMSI, CQGDM, HHCBZDM, CBZLDM, HDHXDM, HXQY, CSYS, CBJZ, ZCCYWMC, ZCDDYWMC, GJCMC, GJCYWMC, GJRQ, GJDDYWMC, AFLGRQ, LGYSZDGD, ZJZZCMC, " +
            "ZJXH, XJMZCS, MZCS, KZCS, MZPSL, KZPSL, HDKFDJ, GX, EDXW, EDCW, CKDEZJ, JSDY, ZDHS, CXJC, JBCL, JBCS, HCSL, SMHCBS, SCDWZ, ZCBSL, JCZDHCDDM, DSKX, FDJGL, GMDSSSBQK, " +
            "CJJGBM, HSJGDM, BZ, TPZJ, CJSJ, CJR, CJJGDM, CJBMDM, ZHXGSJ, ZHXGR, SYRZJ, SYR, SYRDZ, SYRLXDH, SYRFRDB, JYRZJ, JYR, JYRDZ, JYRFRDB, JYRLXDH, GLRZJ, GLR, GLRDZ, GLRFRDB, " +
            "GLRLXDH, STPZH, TZPZDW, ZJBH, CTCL, CYRS, YZCS, YZCZRJ, JLLYXTMC, JLLYJGMC, CBDJRQ, pkid, cjgmc from cbjbxx where CJDJH = #{cjdjh,jdbcType=VARCHAR}")
    Cbjbxx findCbjbxxByCjdjh(String cjdjh);

    //查询船舶基本信息（船检登记号）
    @Select("select CJDJH, ZWCM, ZDW, CBZC, ZJZGL  from cbjbxx where CJDJH = #{cjdjh,jdbcType=VARCHAR}")
    ScsArchives findCbjbxx(String cjdjh);

    //查询船舶基本信息（船名）
    @Select("select CJDJH, ZWCM, ZDW, CBZC, ZJZGL  from cbjbxx where ZWCM = #{zwcm,jdbcType=VARCHAR}")
    ScsArchives findCbjbxxByZwcm(String zwcm);

    //船舶起重设备证书（船检登记号）
    @Select("select JYBH, SYGFN, SYGF, QZSBSL, ZDGZFH, XCNDJYRQ, XCHZJYRQ, QZSBZL, SYRQ, SYDD, ZSYXQ, YCS, FZRQ, FZDWDM, FZDW, FZDD, TDHX, JS, JS1, JS2, JS3, JS4, JS5, JS6, JS7, JS8, " +
            "BZ, ZSYSH, CJSJ, CJR, CJJGDM, CJBMDM, ZHXGSJ, ZHXGR, ZSGS, GXSJ, JLLYJGMC, JLLYXTMC, zsgsform, cjrq from zsqz where CJDJH = #{cjdjh,jdbcType=VARCHAR}")
    Zsqz findZsqzByCjdjh(String cjdjh);

    //海上船舶乘客定额证书（船检登记号）
    @Select("select JYBH, SYGFN, SYGF, KCZL, CKDEZJ, YXCYRSZD, YCS, FZRQ, FZDWDM, FZDW, FZDD, TDHX, JS, JS1, JS2, JS3, JS4, JS5, JS6, JS7, JS8, BZ, ZSYSH, CJSJ, CJR, CJJGDM, CJBMDM, " +
            "ZHXGSJ, ZHXGR, ZSGS, GXSJ, JYLYXTMC, JYLYJGMC, zsgsform, cjrq from zshck where CJDJH = #{cjdjh,jdbcType=VARCHAR}")
    Zshck findZshckByCjdjh(String cjdjh);

    //海上船舶船员舱室设备证书（船检登记号）
    @Select("select JYBH, SYGFN, SYGF, YXCYRSZD, ZSYXQ, YCS, FZRQ, FZDWDM, FZDW, FZDD, TDHX, JS, JS1, JS2, JS3, JS4, JS5, JS6, JS7, JS8, BZ, ZSYSH, CJSJ, CJR, CJJGDM, CJBMDM, ZHXGSJ, " +
            "ZHXGR, ZSGS, GXSJ, JYLYXTMC, JYLYJGMC, zsgsform, cjrq from zshcs where CJDJH = #{cjdjh,jdbcType=VARCHAR}")
    Zshcs findZshcsByCjdjh(String cjdjh);

    //海上船舶防止散装运输有毒物质污染证书（船检登记号）
    @Select("select JYBH, ZSYXQ, YCS, FZRQ, FZDWDM, FZDD, FZDW, TDHX, JS, JS1, JS2, JS3, JS4, JS5, JS6, JS7, JS8, BZ, ZSYSH, CJSJ, CJR, CJJGDM, CJBMDM, ZHXGSJ, ZHXGR, ZSGS, GXSJ, JYLYXTMC, " +
            "JYLYJGMC, zsgsform, cjrq from zshfd where CJDJH = #{cjdjh,jdbcType=VARCHAR}")
    Zshfd findZshfdByCjdjh(String cjdjh);

    //海上船舶防止空气污染证书（船检登记号）
    @Select("select JYBH, ZSYXQ, YCS, FZRQ, FZDWDM, FZDW, FZDD, TDHX, JS, JS1, JS2, JS3, JS4, JS5, JS6, JS7, JS8, BZ, ZSYSH, CJSJ, CJR, CJJGDM, CJBMDM, ZHXGSJ, ZHXGR, ZSGS, GXSJ, JYLYXTMC, " +
            "JYLYJGMC, zsgsform, cjrq from zshkq where CJDJH = #{cjdjh,jdbcType=VARCHAR}")
    Zshkq findZshkqByCjdjh(String cjdjh);

    //海上船舶防污底系统证书（船检登记号）
    @Select("select JYBH, ZSYXQ, YCS, FZRQ, FZDWDM, FZDW, FZDD, TDHX, JS, JS1, JS2, JS3, JS4, JS5, JS6, JS7, JS8, BZ, ZSYSH, CJSJ, CJR, CJJGDM, CJBMDM, ZHXGSJ, ZHXGR, ZSGS, JYLYXTMC, JYLYJGMC, " +
            "zsgsform, cjrq from zshwd where CJDJH = #{cjdjh,jdbcType=VARCHAR}")
    Zshwd findZshwdByCjdjh(String cjdjh);

    //海上船舶吨位证书（船检登记号）
    @Select("select JYBH, LDJBC, DWCK, DWXS, ZLRQ, ZDW, JDW, XWBCSDXRJ, YSWBCSDXRJ, SLKKCCSRJ, SHWKCCSRJ, K1, K2, YCS, ZSYXQ, FZRQ, FZDWDM, FZDW, FZDD, TDHX, JS, JS1, JS2, JS3, JS4, JS5, " +
            "JS6, JS7, JS8, BZ, ZSYSH, CJSJ, CJR, CJJGDM, CJBMDM, ZHXGSJ, ZHXGR, ZSGS, GXSJ, JYLYXTMC, JYLYJGMC, zsgsform, cjrq from zshdw where CJDJH = #{cjdjh,jdbcType=VARCHAR}")
    Zshdw findZshdwByCjdjh(String cjdjh);

    //海上船舶防止生活污水污染证书（船检登记号）
    @Select("select JYBH, SYGFN, SYGF, ZZXS, ZRJ, ZSYXQ, YCS, FZRQ, FZDWDM, FZDW, FZDD, TDHX, JS, JS1, JS2, JS3, JS4, JS5, JS6, JS7, JS8, BZ, ZSYSH, CJSJ, CJR, CJJGDM, CJBMDM, ZHXGSJ, " +
            "ZHXGR, ZSGS, GXSJ, JYLYXTMC, JYLYJGMC, zsgsform, cjrq from zshfs where CJDJH = #{cjdjh,jdbcType=VARCHAR}")
    Zshfs findZshfsByCjdjh(String cjdjh);

    //海上船舶防止油污证书（船检登记号）
    @Select("select JYBH, ZSYXQ, YCS, FZRQ, FZDWDM, FZDW, FZDD, TDHX, JS, JS1, JS2, JS3, JS4, JS5, JS6, JS7, JS8, BZ, ZSYSH, CJSJ, CJR, CJJGDM, CJBMDM, ZHXGSJ, ZHXGR, ZSGS, GXSJ, JYLYXTMC, " +
            "JYLYJGMC, zsgsform, cjrq from zshyw where CJDJH = #{cjdjh,jdbcType=VARCHAR}")
    Zshyw findZshywByCjdjh(String cjdjh);

    //海上船舶免除证书（船检登记号）
    @Select("select JYBH, SYGFN, SYGF, MCYQ, MCTJ, YCS, ZSYXQ, FZRQ, FZDWDM, FZDW, FZDD, TDHX, JS, JS1, JS2, JS3, JS4, JS5, JS6, JS7, JS8, BZ, ZSYSH, CJSJ, CJR, CJJGDM, CJBMDM, ZHXGSJ, " +
            "ZHXGR, ZSGS, GXSJ, JYLYXTMC, JYLYJGMC, zsgsform, cjrq from zshmc where CJDJH = #{cjdjh,jdbcType=VARCHAR}")
    Zshmc findZshmcByCjdjh(String cjdjh);

    //海上船舶散装运输危险化学品适装证书（船检登记号）
    @Select("select JYBH, SYGFN, SYGF, HCJGXS, HCZRJ, SHCLX, SCPZRQ, ZDZHMD, SJWD, ZDYL, ZSYXQ, YCS, FZRQ, FZDWDM, FZDW, FZDD, TDHX, JS, JS1, JS2, JS3, JS4, JS5, JS6, JS7, JS8, BZ, ZSYSH, " +
            "CJSJ, CJR, CJJGDM, CJBMDM, ZHXGSJ, ZHXGR, ZSGS, GXSJ, JYLYXTMC, JYLYJGMC, zsgsform, cjrq from zshsz where CJDJH = #{cjdjh,jdbcType=VARCHAR}")
    Zshsz findZshszByCjdjh(String cjdjh);

    //海上船舶散装运输液化气体适装证书（船检登记号）
    @Select("select JYBH, SYGFN, SYGF, CX, YCZRJ, HJQW, HJSW, YHGXA, YHGXB, YHGXC, YHGXD, YHGXCL, YHGXYL, CANGX, SCPZRQ, ZDZHMD, SJWD, SJYL, ZSYXQ, YCS, FZRQ, FZDWDM, FZDW, FZDD, TDHX, JS, " +
            "JS1, JS2, JS3, JS4, JS5, JS6, JS7, JS8, BZ, ZSYSH, CJSJ, CJR, CJJGDM, CJBMDM, ZHXGSJ, ZHXGR, ZSGS, GXSJ, JYLYXTMC, JYLYJGMC, zsgsform, cjrq from zshsy where CJDJH = #{cjdjh,jdbcType=VARCHAR}")
    Zshsy findZshsyByCjdjh(String cjdjh);

    //海上船舶载重线证书（船检登记号）
    @Select("select JYBH, SYGFN, SYGF, CBZC, CBXS, JBLX, GXRD, GXXJ, GXRDMC, GXXJMC, ZZXZXX, ZZXMX, ZZXX, KXCMCXJ, KXCMCRD, KXMCXJ, KXMCRD, SYZ, SY, FCC1, FCC2, FCC3, ZSYXQ, YCS, FZRQ, " +
            "FZDWDM, FZDW, FZDD, TDHX, JS, JS1, JS2, JS3, JS4, JS5, JS6, JS7, JS8, BZ, ZSYSH, CJSJ, CJR, CJJGDM, CJBMDM, ZHXGSJ, ZHXGR, ZSGS, GXSJ, JYLYXTMC, JYLYJGMC, zsgsform, " +
            "cjrq from zshzz where CJDJH = #{cjdjh,jdbcType=VARCHAR}")
    Zshzz findZshzzByCjdjh(String cjdjh);

    //海上浮船坞安全证书（船检登记号）
    @Select("select JYBH, SYGFN, SYGF, FCWLX, SJSJNL, WC, WNJK, ZSYXQ, YCS, FZRQ, FZDWDM, FZDW, FZDD, TDHX, JS, JS1, JS2, JS3, JS4, JS5, JS6, JS7, JS8, BZ, ZSYSH, CJSJ, CJR, CJJGDM, CJBMDM, " +
            "ZHXGSJ, ZHXGR, ZSGS, GXSJ, JYLYXTMC, JYLYJGMC, zsgsform, cjrq from zshfc where CJDJH = #{cjdjh,jdbcType=VARCHAR}")
    Zshfc findZshfcByCjdjh(String cjdjh);

    //海上高速船安全证书（船检登记号）
    @Select("select JYBH, ZSYXQ, YCS, FZRQ, FZDWDM, FZDW, FZDD, TDHX, JS, JS1, JS2, JS3, JS4, JS5, JS6, JS7, JS8, BZ, ZSYSH, XCNDJYRQ, XCZJJYRQ, XCZJJYRQ2, XCHZJYRQ, XCCDWBJCRQ, CJSJ, CJR, " +
            "CJJGDM, CJBMDM, ZHXGSJ, ZHXGR, ZSGS, GXSJ, JYLYXTMC, JYLYJGMC, zsgsform, cjrq from zshgs where CJDJH = #{cjdjh,jdbcType=VARCHAR}")
    Zshgs findZshgsByCjdjh(String cjdjh);

    //海上货船适航证书（船检登记号）
    @Select("select JYBH, HX, CBZL, XCNDJYRQ, XCZJJYRQ, XCZJJYRQ2, XCHZJYRQ, XCCDWBJCRQ, XCLXJJYRQ, XCGLJYRQ, ZSYXQ, YCS, FZRQ, FZDWDM, FZDW, FZDD, TDHX, JS, JS1, JS2, JS3, JS4, JS5, " +
            "JS6, JS7, JS8, BZ, ZSYSH, CJSJ, CJR, CJJGDM, CJBMDM, ZHXGSJ, ZHXGR, ZSGS, GXSJ, JYLYXTMC, JYLYJGMC, zsgsform, cjrq from zshhc where CJDJH = #{cjdjh,jdbcType=VARCHAR}")
    Zshhc findZshhcByCjdjh(String cjdjh);

    //海上客船适航证书（船检登记号）
    @Select("select JYBH, HX, CBZLDM, TSRYRS, XCNDJYRQ, XCZJJYRQ, XCZJJYRQ2, XCHZJYRQ, XCCDWBJCRQ, XCLXJJYRQ, XCGLJYRQ, ZSYXQ, YCS, FZRQ, FZDWDM, FZDW, FZDD, TDHX, JS, JS1, JS2, JS3, JS4, JS5, " +
            "JS6, JS7, JS8, BZ, ZSYSH, CJSJ, CJR, CJJGDM, CJBMDM, ZHXGSJ, ZHXGR, ZSGS, GXSJ, JYLYXTMC, JYLYJGMC, zsgsform, cjrq from zshkc where CJDJH = #{cjdjh,jdbcType=VARCHAR}")
    Zshkc findZshkcByCjdjh(String cjdjh);
}